I lived there the past 7 years. You'll love it, period. As far as snowboarding goes... Norquay is the closest hill, just on the side of town, but it's tiny with basic "ski racing runs". They have a pretty good park though! Sunshine Village and Lake Louise are the major resorts. Sunshine Village = 15 minutes from town. Lake Louise = 50 minutes from town. Lake Louise probably has the better terrain (lots of blues/singleblacks) but Sunshine gets almost 3x as much snow! (350cm vs 900cm). At Sunshine it's laid out kind of different than most hills.... lots of super steep sections, and lots of completely flat spots. It's great! If you can find the good runs (ask a local) you can have fresh pow anytime. Now, if you really want to step it up, consider taking a day out at Kicking Horse (1.5hrs west of banff). It's tall (4133 vert, bottom to top gondola), very steep, and usually good snow.