The South Carolina coastal gem offers more than sand and sun, it’s a musical must-visit