If you're after a place with a kitchen(ette), the Canadian Rockies Chalets and the Rocky Mountain Ski Lodge both do, and their rates aren't bad at all. (both in Canmore)
Is anyone able to confirm for me whether it's possible to get bus transport from the Bow Valley Trail to both Sunshine and Lake Louise? And do they actually pick up from other places along that road? (Their web pages say No, but their pdf schedule says Yes...) I'm doing research for a trip next northern winter, and it's kinda hard to do at this distance!