Pumped hydro does not need to consume water, it can pump the same water over and over. In some places, it can use saline water from the ocean.

The EU report says hydro power can help agriculture e.g. if big reservoirs are built and on dry years the water from them can be used in agriculture.