For more detail this asset from the Unity Asset Store: Click Here
This is a paid asset, but now you can download Water Splashes for FREE, Please keep in mind this package is provided only for learning purposes or to be able to test before buying the product, NOT FOR COMMERCIAL PURPOSES.
Water Splashes v1.3 (Latest version)
Water Splashes v1.2
“If possible, please buy the package to support the developer”
A collection of water splash special effects!
Two types of splashes are provided, both of which come in three different sizes. The splashes are comprised of multiple effects, including water jets, wake, ripples, splash droplets, mist and sound effects.
New to version 1.1, all the splash effects can now be scaled to any size.
For a great example of the water splashes in action, you may wish to consider the excellent Poly Fleet pack.