In reply to nameless_rob:
If you're just planning on cragging, a 60m single will be fine for the majority of routes. There's not too many that need a 70m.
Venues - if you're around Banff, I'd head to Canmore for the easier sport climbing. Grassi Lakes has some good easy stuff (think giant limestone pockets), plus a couple of VERY well bolted 5.10's (around HVS, but super safe and juggy) if you're wanting to up the grade a bit. Look for the 'Golf Course' area and Gardener's Wall. Also Wasootch Creek towards Calgary a bit (in Kananaskis Country) has loads of easy stuff, some of the bolts are a bit spread out though on the easier routes, could be worth taking a cut down rack there too. Cougar Canyon in Canmore also (cool area too, nice walk up a creek).
Just off HW1 before you get to Canmore (from Calgary) is Kid Goat - some bolted multi-pitch, some requiring gear.
In Banff, the back side of Tunnel Mountain has some easier stuff, single and multi-pitch. If you end up taking gear, 'Gooseberry' is a multipitch 5.7 on there, partly bolted, bolted belays.
Most of the easy (5.4 - 5.7) multipitch climbing tends to be trad or mostly trad.
Back of the Lake in Lake Louise is good, again some trad, some bolted, some easier stuff there. Does tend to get busy, but then so do many areas. Quartzite (kind of like climbing on frictionless grit!) unlike most of the Rockies which is limestone.
Don't know Jasper area as well, but there is definitely some easier bolted stuff around up there.
For guidebooks, 'Sport Climbs in the Canadian Rockies' covers Canmore/Banff/Lake Louise areas, including the trad routes where these are interspersed with bolted routes. There are a few topos (eg. Kid Goat) here:
http://www.banffrock.ca/indexBVR_guidebook.html - the Bow Valley Rock guidebook (trad but includes the bolted routes in predominantly trad areas) is out of print but pdf's are on this site. 'Banff Rock' has just been reprinted, not sure exactly what that contains now.
There is also a book called 'Canadian Rock - Select Climbs of the west' that is lovely and very easy to use, covers areas like Squamish, Skaha etc too if you ever head further west - very select though. IIRC it covers Grassi Lakes, Back of the Lake, some stuff near Jasper (?). Sorry my copy in still in Canada else I would look for you.
Seeing as you're going at the end of Sept, be aware that for scrambling many of the peaks will have at least a dusting of snow by that time, it has snowed there up high already.
Have fun, it's an amazing area.