You could try the Paint FX waterfall. It's really cool, but I'd probably only use it if you were looking just to stick a waterfall in the background, cuz it's fairly recognizable unless you mess with the colors and whatnot.

If you wanted objects to interact with the waterfall, you'd probably want to use particles.