They just built this indoor water park in Fitchburg, MA (of all places) with hotel and kid-friendly activities. I understand that it's a huge success. A destination with overnight accommodations. Skiing (in the winter) during the day and water sliding at night? Perfect for the Weirs??
http://www.greatwolf.com/newengland/waterpark