In Traverse City (near the top of Lake Michigan) we planned for and surprised the kids with an all day and overnight stay at the Great Wolf Lodge.  It is a newer hotel chain sprouting up around the USA with a covered attached water park and lots of activities for the kids.