Plans by Irish Water to revitalise a drought-stricken village’s water supply have been described as “completely off the wall”, and dismissed as “throwing water into a hole”.