I am also a CM, although I'm currently a recruiter for the college program. I worked on the college program for 9 months and I came out at Disney. I can assure you a cast member would never make a negative comment. As far as dealing with other people, let me tell you this story:
I'm taking my boyfriend to WDW for the first time. We live in a relatively conservative area. We hardly touch eachother in public, although we have gotten a little more relaxed in the last year. However, when we go to Disney all bets are off. Am I going to be making out in the park? No. Will I hold hands? Absolutely. I'm a mobile DJ and I'm not afraid of talking in front of large numbers of people. Am I going to make a huge scene about two people loving eachother, get down on one knee, and give him a ring in main street square on December 23rd? YOU BET. Why? because there is nowhere in the world more accepting of the LGBT community than WDW and Disney as a company.
It is possible that a snide comment could be made. As far as which resort to choose, I would say choose a family one. All Stars or Pop Century would be a good pick. You'll fit in with others even if you think you're going to stick out. If you look at Pop Century vs the Grand Floridian, where do you think you'll stick out more? I might be stereotyping a little bit, but Grand Floridian=money=republicans=conservative=don't like gays, especially ones with children. Again, not saying thats always the case, but it's my opinion based on experience.
congrats to you and your partner for taking on the challenge of children in a society that doesn't approve. I say with complete certainty that there is no better place to go to relax as a gay couple with children than WDW