It’s a very special place, says Tommy Barker, near so many coastal and river attractions, an hour or less from Cork and Waterford