Welcome to the forum. From that list, the only option is Waterford Aero Club (http://waterfordaeroclub.com/
). AFTA are a great school in Cork but their main aim is commercial flight training so there would be little opportunity to rent there. Kilkenny Aerodrome is mainly used for Parachuting, I don't think there is a flying club there any longer.
Waterford have recently taken delivery of two Cessna 172's (before that the used the Tecnam P2002). If you're interested in travelling a little further north, there's a new flying club at Limetree Airfield just north of Portlaoise. They operate two ICP Savannah S aircraft - https://funflyaerosports.ie/
. The site is mainly for the aircraft dealership but if you contact Mark via the website he'll give you the flying club details.