I'm an athiest. When I was in college I was a lot more vocal about it than I am now, nowadays it is pretty much live and let live, unless I see harm from the practice, and most of the time I don't. My mother-in-law is a now-retired Episcopalian minister, we get along just fine.
My parents weren't particularly religious, my mom was raised Shinto-Buddhist but pretty much dropped it when she came to the States, my dad was a "bad" Jew, and played pool rather than going to Hebrew school so never got a bar-mitzvah. Both are incredibly moral people. They raised me on morals not based on a specific religous guideline, but rather very much by the Golden Rule, you know something like "therefore all things whatsoever would that men should do to you, do ye even so to them". They never told me to believe in a god or not to, they even sent me to some Christian denominations Sunday school and church so I could get the experience.
I raise my kids the same way, my wife isn't very religious, but I think she enjoys the community of the Church, so she still participates and my son goes to Church with my mother-in-law. My son has been making some pretty funny comparisons between God and superheroes, I have sort of struggled on how to respond to that.