Shake up your fall weekends with these unexpected getaways just a short road trip from Raleigh—from New Bern to Rock Hill and more.