hey...I'm a bit toasted now....so I'm not sure if my answer will make sense. Feel free to contact me through my profile (e-mail or IM) if it doesn't.
So I live in Salt Lake, and ski at Alta (and backcountry):
If you want to party, stay in Park City...and ski with the snobs. That's where the rich people go, but the night life is a ton better, so I've been told. I have never gone to bars there, but I have skied the Canyons. Sucks, compared to Alta/Bird.
The best three resorts in the Salt Lake area are:
1) Snowbird - best terrain/and snowboards (blah) are allowed.
2) Alta - best terrain, and the "who the hell cares what you are wearing" crowd. The best skiers in Utah reside there...except snowboarders -- not allowed. Skiing at Alta is a humbling experience: when you watch someone throw a full back-flip off of a 30-footer right under the chair, or someone goes switch tele off of a line that you wouldn't even consider, yeah...makes you want to go down to the parking lot and just drink your beer.
3) Solitude: a nice mountain, some extreme terrain. Nice groomers. A good place to spend a day.
if you are interested in drinking and the bar scene. Stay over in Park City, and ski the Canyons, Park City, and Deer Valley (no snowboarders there, either)
if you are interested in skiing. Stay in Salt Lake City, and ski the three I mentioned.
Most importantly, realize that the base elevations are 6000+ feet. When I moved here, it took me a full two years to adjust. Plan on altitude sickness (headaches, fatigue). Drink lots of water, and carry aspirin. In fact, if you are really here for the skiing, you may not want to drink...since that is a dehydrator. But it's your party.