Make sure you visit Cochrane and Okotoks. Cochrane is ideally located if you like mountain sports, plus you don't have to take the Deerfoot in the mornings if you work downtown.
I've visited many bedroom communities around Calgary in search of what you speak of. Chestermere, Okotoks, High River, Bragg Creek, Turner Valley, Airdrie, Black Diamond. Cochrane seems to have it all, plus it's right on the river.