Avoid Calgary International if you can as there will be landing fees and they are really not keen on having light aircraft landing there. They've basically booted out most GA planes and forced them to move west to Springbank (CYBW). Springbank is GA friendly, no landing fees and you have a great view of the mountains you are about to cross. CYBW is about 10km west of the Calgary city limits.
Calgary VTA on 119.4 will be helpful and friendly as you cross through their zone and hand you off to Springbank.
There is a guest house right on the airport you may be able to book for an overnight stay.
I'd concur with George's advice here: do your trip though the mountains on a relatively calm day and follow the highway. Mountain turbulence and downdrafts on a nasty day can easily exceed an RVs climb capability. On a smooth day, it will be an awesome trip.