Looking to buy in TN or KY, need advice

We've got family in Clarksville TN and we are considering making a move to that area. We are not set on being right next door to Clarksville, anywhere within a couple hours drive would be close enough. We would like to get a nice home on or near a good recreational lake. Can you give us some recommendations on where to look and where not to look. Our family knows nothing about the lakes in the area as they are not into fishing/riding at all.

Are there any good lakes in that area for watersports? If you know the area where would you be looking to buy a nice home? We would love to have an area big enough and that is zoned for horses as well. We have been looking at everything from lots/acreage from $50K to homes already built on acreage up to $400K, just don't know the area very well. Anything you can throw out to us would be great!