Lots of good boating around Calgary. I moved up here from Denver a couple years ago. The Kananaskis (about 45 min from town) is good for play (scheduled flows every day so you can boat year round if you can tolerate the cold). Brierlies on the North Saskatchewan (about 1.5 hrs) and S-bend on the Red Deer are also really good play spots. Lots of good creeking too. We're also close to lots tons on good boating in BC and Idaho. The whitewater park in town is scheduled to be completed next year (maybe) so once that's done we should have sweet playboating right in town. Check out www.paddlingabc.com
for some info about the local runs.