Depending upon the weather, visibility and amount of water these views can be quite spectular.

Cohoes Falls http://ny.water.usgs.gov/rt/pub/01357500.htm

Ausable River http://ny.water.usgs.gov/rt/pub/04275000.htm

Reynolds Channel at Point Lookout either as a webcam http://ny.water.usgs.gov/rt/pub/wc-01310740.html  or as a movie http://ny.water.usgs.gov/rt/pub/wc24-01310740.html
BTW – I always like to put in a plug for another of my favorite webcams (actually there are 3 separate cameras); The ‘wolfcam’ in Ely, MN. http://www.elyminnesota.com/cams/wolfcam/index3.php If you catch them feeding a deer to the wolves – it too is a spectular view.