Hmm I'm not from the US but I guess you could try narrowing your search to non-alpine lakes of California, Oregon and Washington. These states have tons of lakes all over, and as long as they are not very high in elevation, they tend to have a pleasant, mild climate year round
. There's also lots of towns and communities around these lakes from what I know.