You mean like this?
Lake Tippecanoe in Indiana...
Friendly locals who like to party. Expensive houses and cottages. Sandbars to park the boat and swim. Great fishing. Friendly bars. Lakes can be crowded on weekends but not bad during the week. Small town Indiana atmosphere combined with plenty of vacationing, usually prosperous, Chicagoans.