Whether it’s the historic charm or booming cultural and culinary scene, there’s a reason people are flocking to Charleston