Charleston, South Carolina's famed harbor finally has a waterfront hotel. Here's everything you need to know about The Cooper.