Hey everyone! I'm kinda new to blender but im working really hard to familiarize myself with the program. I'm trying to create a rough waterfall scene but im not sure about the water and how to make it look real. Any help would be greatly appreciated!!

Here's some good info on that:
http://wiki.blender.org/index.php/Doc:2.4/Tutorials/Materials/BSoD#Part_3:_Creating_the_Waterfall.2C_and_Lava_Effect.2C_using_Blender_Material_Nodes