If you go to Frankenmuth you will find an indoor waterpark.
Here is a list of indoor waterparks in Michigan
I do know if you camp at
Sauder Village in Archibold, Ohio, you can use the motel pool for no charge. Walking thorough the village is also very good as well as the onsite restaurant.
Dale