Could be wrong, but I don't think a domestic tank-on-a-stand will give you enough pressure to drive the sprinklers sufficiently...
Anyway, why do we need them on the roof? - Most houses are lost, AFAIK, from ember-attack blowing into the roof-void via the eaves and other exposed openings.
Speaking of holes... windows and doors are a real weakness. Strong and variable-direction winds can bring debris as well as embers...and break the glass. Doors can be blown out as well as windows, caused by a well-sealed house being effectively pressurised in comparison to the low(er) pressure exterior conditions generated by the fire-front.
Perforated window-shutters and metal-mesh security doors would be the best way here...- Open internal glass windows and solid doors to allow the air-pressures to equalise.

