The Boglehead forum has a thread about Niagara Falls:
3 day stay in Niagara Falls on the Canadian side. Hotel has an indoor water park to keep kids happy for the evenings. Planning on taking boat trip to view the falls. Any other family activities to suggest?