With museums, galleries, boutiques, and a scenic lake with trails, water sports, and camping, this charming South Carolina city is a must for your bucket list.