I've travelled from Manitoba twice so far.
First time I camped at Sibbald Flats Campground. Was a really nice camping spot. Just a quick drive from the range. However, there are no reservations and apparently it fills up quick on a nice weekend from Calgarians fleeing the city. I arrived on a Thursday and had my pick of spots. I think it was something like $25 a night. I did spend some nights camping on the range. The only thing I didn't like about that was that it is a gun range; As soon as the sun is up, someone is shooting.
This past summer I left the tent at home and treated myself to staying in Cochrane as suggested by prairieguy. You have your pick there between major chains (Best Western, Ramada, Super 8, etc.) and local motels.