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.