Check out Timberborn, it doesn’t check all of your boxes but a lot of it revolves around water management - building dams and reservoirs, diverting rivers, surviving dry seasons, etc. At its core it’s just a fun city building game and I highly recommend it if that sounds good to you. It’s 20% off ok Steam right now too.