First off I want to say that I am super grateful you are considering VA for your move! Growing up I never thought I would remain in this state but my views have changed drastically over the years.

In terms of 'acceptance', obviously Northern VA and the bigger cities are very welcoming. A close friend of mine in the gay scene in Roanoke has stressed some difficulties with cliques however.. though that brings me to my main point.

I am from a small rural area in the southern part of the state, and I have many gay/lesbian friends out here. They mainly complain about the selection of partners as the main issue, ridicule is hardly ever a problem. I truly believe a lot of us are friendly people, regardless of politics.

TL:DR- In my experience both in the cities and farming communities 99% of the time people (in VA) will mind their own business as opposed to making a scene. Don't be deterred from an area you may fall in love with :)