Paint FX would be perfect, and FAST, for this if you don't need to go too close.

Just draw your waterfall path curve, and attach a waterfall brush to it

simple.

Fluids for this are another story