The ski jump hill is now called Canada Olympic Park (COP) although many of the locals still call it Paskapoo. Lots of local Calgary kids learned to ski there. It's a decent place to make a couple of turns and dial in equipment, and they have night skiing.
D-sub, I'm not sure what you do for a living but if you're independantly wealthy and can just pull up stakes and move wherever, the place you want to be is Canmore. It's a town just on the east side of the Banff National Park border. As it's not allowed to purchase property in Banff unless you are a full-time working resident, many people who want recreational property near Banff have purchased in Canmore. Lots of people have retired there too. Not sure how big it is now, 10 or 20,000 maybe? Big enough to have a good selection of restaurants and shops anyways. All the retirees and such have seriously pushed up real estate values there.
From Canmore, it's maybe 20 minutes to the Sunshine turnoff (then another 10-15 to the parking lot). Louise is another 30 minutes past the Sunshine turnoff.