A proposed wind farm development will have “catastrophic” consequences for a Co Cork town’s public water supply, according to a health and safety expert.