Making a waterfall

I have read tutorials on making water surfaces, but is it possible to make a waterfall? Or maybe fake it. In my level the player won't actually be up close to it, rather can see it from a tallbridge at night so even an appallingly simulated waterfall would be better than nothing.