i went to school in iowa city for college, just moved away 2 weeks ago, been there since 2003. knew several transfolk there (really randomly too, through my D&D group). i have never lived in a more accepting place, i'll be honest with you. we had some protesters and come by when gay marriage passed. this guy in a suit stood on the pentacrest (main campus green) and started preaching the usual hate. you know what happened? random students surrounded him and listened to him, argued with him, and then several went up and hugged him until pretty much the whole crowd did. just random students! it was pretty amazing, considering he didn't deserve it after saying the things he did. he was shocked too, i think. he didn't say a word, but he packed up and went home and i never saw him again. before that, he was out there every wednesday afternoon for months. not saying a hug changed him, who knows, but it was an amazing thing to see.
anyway, the western half of the state is pretty "conservative" in terms of LGBT rights, and the eastern half is quite "liberal" to use the political terms (though i don't wanna get into politics). the midsection is des moines. fairfield, well i have never been there. it's a little south of iowa city, and so it's close to missouri... hard to say. it looks far away from any big town so it's probably going to be excruciatingly boring there, if nothing else.
yes, it's not all sugar and honey, there are always fools everywhere, but overall iowans are pretty practical, in general. they mind their own business, or at least that was always my experience. it's not as religious as the bible belt (where i am from originally), and it has done a lot in the state for civil rights (racial, gender and glbt over the years).
sorry to gush on iowa, but your question pulled me out of lurking. i consider myself iowan even though i only lived there about 1/2 of my life (briefly as a kid in Ames + college in Iowa City). but compared to the Florida/Georgia border where i lived for the other half of my life, heh, yeah... Iowa City was amazingly accepting.
good luck. i hope you like corn and snow, since those are the two seasons. =)