Americans are increasingly choosing to drink less or not at all. So what does that mean for party cities across the country?