Where are the under-the-radar, but thriving towns with a lake or river system as the main draw? I'd like it to be in fly-over country and north of Missouri. The Great Lakes are almost TOO great for this question. Think smaller.
Bonus points for:
Strong local identity
Arts or Cultural attractions
Nearby Forests
Good schools