Whistler for me chap. Did a season there on a board in 2003. The infrastructure has improved a bit since I last went in 2006 what with the Olympics and all that - better road up from Vancouver and a high speed lift between Whistler and Blackcomb mountains. Loads of bars a several nightclubs to keep you busy, cinema, loads of restuarants etc. Loads of shops, a massive supermarket and offy in the village so if you get a condo or a chalet you can do a bit of self catering or whatever. You can always bomb down to Vancouver for a day/night out if the weather's shoite or you fancy a rest day or whatever. There's a particulary good burger place in Van called Hooters!
When it snows it snows! Last week they had 2 metres with 25cms regularly falling overnight.
The very best place I've been for snow is Fernie in British Columbia. It's about two hours west of Calgary. The town is tiny and there's not much there but it sits at the foot of 5 massive bowls. When we rocked up the snow was 16 feet deep. Powder up to your balls (eye variety!).