since we're already on the topic of water harvesting and storage. maybe someone will find this beneficial.
the house will have 3 ceiling slab for water storage. i've spec-ed these area for slabs since they can't be used for anything better.

the area is enough for 6 of the biggest tanks, 500 gallons each.
roof structure will be spec-ed not to intrude in this area. which i think is really possible since we're kindda decided for metal roofing, which doesn't require complicated support structure.
anyway the problem is, is to have that much water on top of your head. if should the tank burst it's gonna flood the house. it's a real problem and my cousin had gone through it before. it flooded her house, destroying nearly half of the house.
she had a single 300 gallon tank in the ceiling. we're gonna have 6x500 gallon tank. that's more than 12 tonne of water.
so we're designing the house to have brick wall closing the tank area. the tank is essentially outside of the house, covered by fascia board.

see the front portion? that will be fascia board.

the tank will be shielded by brick wall on all sides, except for the front. if for any reason the tank decides to burst, it'll at least be shielded from flooding into the house.

fascia board.

the toilet slab will have 3 sides covered by walls.

one of the side wall will have 2 feet of barrier. leakage pipe will be directed outside of the house and 2 more downward to the toilet beneath.
but if it's still not enough, at least only one room will be sacrificed.
would it be sound practice if the slabs were perforated with a 6" drainage hole for maintenance purposes (tangki wash) as well as emergency drainage in the unlikely remote event that the tanks do burst.
Although not related to rain harvesting but more to plumbing, would separation of pipes for toilet and shower/basin taps be practical such that the latter two can be on pump if needed but the toilet one without it.