Where does the water used for irrigation go

Where does the water used for irrigation go? Is this consumption