Microphysics of Water Clouds in the Atmospheres of Y Dwarfs and Temperate Giant Planets