Some quirky, unique hotels make the list of the best places to stay in Charleston, SC