Water will be the biggest reputational and economic risk facing industry and government in the Pilbara by 2030.