When my husband and I were deciding to get married, we talked a lot about our faith or lack thereof. I grew up a Lutheran PK (preacher's kid); my husband grew up Catholic with one parent Catholic and the other agnostic. Faith has been a part of most of my life; my husband "quit" the Catholic church in high school and would basically call himself an atheist or agnostic (I can never get the two straight). He's not even sure he believes God exists. He's respectful of those with faith but doesn't personally ascribe to such beliefs.
When we talked about raising kids within the church, he was supportive, saying he thought it was a good foundation that never hurt him. He himself didn't feel the desire to go to church but he would support me in my interests. In fact, he said he would probably go with me as well, in order to provide a family experience within the context of church. But it depended on the church.
I have gone to many different churches in my life, having grown up in a very ecumenical family. Although I was raised Lutheran, my parents made sure we occasionally went to different churches or synagogues to know that God could be worshiped in many different ways. In my adulthood, my dad was the director of a Muslim, Jewish, Christian trialogue in Detroit, further opening our family to different faiths.
I have gone to Lutheran, Methodist, Southern Baptist, and United Church of Christ churches (UCC is a blend of old Congregational churches and _____________ in New England). Meanwhile, my husband worked in the Middle East and Africa and knew many quietly faithful Muslims who he respected and they appreciated his respect.
So, when our son was born, I church-shopped all around our area and found one I felt comfortable with--a small UCC church. When talking with my dad about the different denominations, he said something that still sticks with me today. He said that the atmosphere of the individual church I choose is probably more important than the specific denomination. Some would argue against his thinking, but I found it to be true. It is the people within a specific congregation that make or break it for me. So, I basically chose the one that felt the most in line with my thinking and personality. Like I said, it turned out to be a small UCC church.
Ironically, my husband, our son, and I have gone there for roughly 12 years although I'm the only one that is officially a member. My husband couldn't in clear conscience make a statement of faith that rang true for him. But in all honesty, he goes more often than many actual members do. Most people wouldn't have known he wasn't a member other than I mentioned it at meetings on occasion. Plus, we never baptized our son. We thought we'd do it when a second child came along and they could both be baptized at the same time. But a second child never happened. (I've had a few arguments with God about that one.)
My only caution would be how you feel about membership and baptism. We are fine with me being a member and my husband being a "friend" of the church. However, our son just figured out a year or two ago that he wasn't baptized or a member. He was 11 at the time and that confused him. To be honest, we didn't even have a very good answer when he said why not. Perhaps it was representative of our differences in belief. Perhaps it was also our way of letting him make the decision himself when he got older. However, instead he felt a little left out, awkward, and perhaps hurt, feeling like we didn't care enough to baptize him. (The funny thing is...my Catholic mother-in-law seems to think that her oldest son is our son's godfather. I'm not sure where she got that from because we never baptized him. Talk about awkward all around!)
It might be good for you and your husband to think about membership and baptism before you get to that point.
Our son has moved past that spot now, I think. He is twelve and is active in the youth group. We continue to go regularly. However, it put him in a spot where he didn't necessarily have all of the intellectual and emotional maturity to know how to deal with it. The questions will likely rise for your child(ren) as well if you follow our path.
Best of luck! My husband enjoys going with us to church. He enjoys the community of people there. And so does our son. It certainly has been a good source of conversation at times, to say the least!
So, can anyone relate to your situation? You betcha!