Digital Photography School has a neat basic primer on how to photograph waterfalls. Even though you're not a shutterbug, you'll probably still appreciate several of the fantastic photos they have on the page: Link
This one above is taken at the Chittenango Falls State Park, upstate New York: Link [Flickr]
If you like that one, I bet you'll like what I consider to be one of the most beautiful waterfalls in the world: The Plitvicka Waterfalls in Croatia, taken by Jack Brauer.
They look phony when the water looks all gossamer.