The secret is out. The once sleepy Southern town of Greenville, South Carolina, is becoming a fast favorite for travelers in the know.