I live in Niagara Falls Ontario. You can try The St. Catharines Flying Club. I know they rent out Cessna's. If you are looking for a helicopter tour over th falls you can check out Niagara Helicopters Ltd. The links are below.
http://www.stcatharinesflyingclub.com/