A North Carolina city was just ranked the most affordable vacation destination in the U.S.—here’s what to do there.