In reply to travlinmatt:
There's a huge amount of choice around Canmore, from massive trad undertakings to full on sport. A lot of it is in the middle, bolted but by no means a clip-up. I have done literally a few days around there, so have done the research but not personally experienced very much.
As noted, the 'Back of Lake' at Lake Louise has plenty of very good quality sport climbing in an accessible spot with a nearby cafe etc. You can take anything from that to very committing trad routes on Mount Yamnuska within a short drive from the Canmore area.
The best guidebook is Canadian Rock: Select Climbs of the West. This covers a very big area, but has pretty good topos and brings together climbs that otherwise are spread across lots of different Rockies are guidebooks. I'm sure places like Needlesports will stock it.
If you want big, adventurous sport on amazing crozzly limestone, take a look at some of the areas south of Canmore. Don't be fooled by the bolts.
Have fun!
Post edited at 17:19