I just saw this thread and am happy to help with the area if I can...realtors, areas, schools, etc. We live south of Nashville and have a cabin about an hour and 15 min away on Center Hill. From what you are describing, it sounds like you may prefer Old Hickory or even a marina on the river like Rock Harbor or the Commodore Yacht Club. That way you could navigate the Cumberland River. Center Hill, Tim's Ford, Percy Priest, & Dale Hollow are not navigable outside the lake.
Many folks from south of Nashville go to Center Hill and Tim's Ford. Both are nice lakes. Center Hill is a deep clean water lake, although it will be lower than normal the next few years as repairs are made to the dam. Dale Hollow is 2+ hrs from Franklin.
Andy, while you are right about my Vols (I am headed to Knoxville tomorrow--hope it is respectable Saturday.....and Vandy is undefeated and number 1 in the SEC east for at least 2 more days, can you believe it), you will need a trailer to get from Tim's Ford to the Tennessee River. Tim's Ford is on the Elk River. While I have not been to the lake, I have put in at the dam on a 4 day canoe trip on the Elk with my son's scout troop.
_________________________
2000 Hurricane Sundeck 217
2005 Acura MDX
2006 Volvo S80
2000 Chevy Silverado 2500
1974 Mercedes 450 SL