I suggest living close to downtown in SLC, people are more liberal there and tend to get a lot more conservative as you move out to the suburbs. I live near Liberty Park and really love it there. I've also lived in Emigration Canyon and loved being up in the mountains but I prefer the convenience of being close to the work, grocery, etc. It also depends on how much you are willing to pay... the farther East you go, the closer to the mountains you will be but you will also pay more.
I've heard Vancouver Island is absolutely beautiful and I don't know if Salt Lake can compare but it is pretty easy to get out into nature here. The mountains are very accessible even from the middle of the city. Also the Jordan River trail is nice. Then there's always interesting areas like the Great Salt Lake and the Southern Utah desert (Moab) within a few hours range.
Check out Wasatch Community Gardens. It's not really a CSA but if you want to do the gardening yourself it's a good group to get involved with. I joined East Farms CSA last year and like it okay but it's at least an hour away and we never actually visited the farm, although I know others who did.
Our little Urban Homesteaders moms group is fun... you're welcome at our monthly get-together when you get here!
Good Luck! We'll see you soon!