Welcome Steve. My husband and I are also from the Nashville area. There are several nice CGs in our area. Most all are on lakes or rivers.
Check Craigslist for the Nashville area and you will find literally hundreds of RVs for sale in every price range. But be careful. The second used RV we bought had many problems we were too "green" to see and were really taken. If you can take someone with you who has some years of experience, that would be great.
After that awful and expensive experience the next two we bought were brand new. Now on our 4th RV, we finally found exactly what we need and were looking for.