This South Carolina town ranks as one of the best for travelers with pets. Here’s why