Here is a link to Travel Alberta. Check the Campgrounds listing for Calgary. Depending on the direction you are coming from you have to decide what works for you.
I would recommend Calaway, Calgary West if coming from the west.
If coming from the south I think Pine Creek.