You could do just fine in Rocky Mount, and you're just about 30 minutes to Roanoke, and 15 minutes to Smith Mountain Lake. There is a nice cafe in Rocky Mount's little downtown, a nice modern library, a farmer's market and so on. Check out the Franklin News Post online:
The Franklin News Post - News from Rocky Mount, Virginia
From there you might get a better sense of community events and so on. Rocky Mount's pop is 5,000 but it's the county seat for Franklin County, pop 51,000 so it feels larger. It has retail to support the county (Super Walmart, Lowes, multiple grocery stores, etc).
I'd say, pound for pound, Rocky Mount has alot more going on then your average town with 5,000 people. But it's still a small town so keep that in mind.
Sean