Most farmers are in support of gay marriage with campaigners hailing a "transformation" in attitudes to gay and lesbian people in rural Ireland.