A Tory councillor who wrote a tweet during the Eurovision Song Contest in which he referred to Irish people as "gypsies" has resigned.