Lots of boating in this part of the world in May. How long are you in the area? There is a big Whitewater festival happening in Pincher Creek on the May Long weekend, a few hours south west of Calgary.
Best place to get good rental gear would be Aquabatics Calgary, good whitewater shop.