I think its fine to have a few responsible drinks with kids in the house.Obviously not enough for you to drunk.I think as long as someone is in good enough condition to deal with an emergency should one arise (ei drive someone to the hosital if needed) it should be fine.
My partner has worked in a pub for the last 10 years and is really into the whole drinking mentality.While my dad was an alcoholic until I was little,he stopped drinking when I was a baby and because of that there was absolutely no drinking in my house whatsoever.
Saying that I wont expect my partner to give up having a few drinks in the night every week or so.(i know he wouldnt happen nightly or anything)as long as he doesnt have too many.I dont really drink much at all.Now that i've stopped drinking because of the pregnancy I think that when I have bub i'll only drink if I have a night out on the town.Otherwise i'll always be sober steve at home.