A small coastal community has the worst infrastructure in Co Cork, with its roads, water and sewerage systems being described as “Third World”, according to a local councillor.