MINDS: water reservoirs of compact planet-forming dust discs: A diversity of H2O distributions