From downtown hotels to beachfront resorts and secluded farm country inns, here’s where to stay when visiting the Yellowhammer State.