A good waterfall picture is done as a blured water ... falling. This can be done by opening the cameras shutter for a long period of time. About 1/2 second works quite well. If your scene has too much light to leave your shutter open for that long you need to use a neutral density filter.
From HowTo Wiki, a Wikia wiki.