I would look at Banff or Revi. Living on a hill and it being cost effective is not going to happen. Revelstoke gets lots of snow but its a bit light on nightlife. Kicking Horse is close as are a few others.
Banff is good as the season is long and the snow is stable. (never rains on hill)Plus you have good nightlife and loads of hills nearby. No matter what your plan having a car will be a good idea so you can road trip to where the snow is. The worst hill in Western Canada with fresh snow on it will still be better than anything you have ridden in oz.
So many runs so little time.