Active and integrated management of water resources throughout CO2 capture and sequestration operations