A sporting venue that has deep symbolic importance for the people of Ireland will be visited by the Queen during her tour of the country.