Just out of town is great place to be up-close to the water, very dramatic...
http://www.tripadvisor.com/Attraction_Review-g154998-d507148-Reviews-White_Water_Walk-Niagara_Falls_Ontario.html