Visiting South Carolina’s coastal city? These are the hotels to bookmark