Nearly €1m of taxpayers’ money was wasted on acquiring land in Co Cork for a fire station which was never built.