In reply to Gabe Oliver:
Hi Gabe
Hire car is probably the best option.
It means you've somewhere to leave a few luxuries/change of clothes. Plus the walk in/out from the parking to the campgrounds isn't really that long, especially if you're not carrying much, so bailing for a day or 2 to get beer/pizza/showers/supplies etc if weather's crap or you need a rest is highly feasible rather than just sit it out in the tent.
Plus there's good climbing around Lake Louise, Canmore, Yamnuska Rock, etc which are all only a few hours away as alternatives.
Your only other option rather than a hire car would be to throw some cash at a local to drive you in and out. For summer 22 there's time to sort this out, but to make it worth their while might end up being ~70% the cost of the hirecar without the flexibility.
Some people you could approach for ideas are:
The Alpine Club of Canada (Calgary section) - huge membership, someone may say yes.
Yamnuska Rock (guiding service) based in Canmore.
Dogtooth Climbing gym in Golden.
Post edited at 02:05