The wait is over: Charleston’s luxury waterfront hotel is now open