Download Waterfall set FREE Unity. 

Realistic waterfall with splash falling water particles, the water can collision with any mesh collider give naturally feel of the water and easily embed in your terrains.