How do you teach your children about religion and faith when you and your husband belong to different religions?

My partner will be converting to my faith but he is pretty much an atheist before even though he was baptized as a child. In general, religion is not a big deal in his family and country as a whole but it is in mine. We have decided that we will raise our child in my faith but also to teach him or her about religion from a sociological point of view. I wouldnt want religion to be just a cautionary and scary thing the way I was brought up (eg if you don't do this, you will end up in Hell). Religion, regardless of whichever, should be a positive guiding force in our lives not a scary cautionary bogey.