Museums are going to cause you several problems.
As Thothguard51 says, insurance insists on a lot of things. Combine that with the building code for a building having a number of people moving through it, and you have a sprinkler system tied into an alarm system. As Orianna2000 says, sprinklers come on quickly and contain the fire. Further, as soon as the head goes off, the fire alarm will be triggered. The whole thing is designed to produce minimal damage. A modern museum will also have fire doors that are closed at night to prevent the spread of fire.
Of course, depending upon what the sprinklers hit, it would get wet. But the museum's management is going to be notified very quickly and will take steps to minimize the damage. If nothing else, you throw the stuff into big walk-in freezers and let the stuff freeze until you figure out how to protect it. Fire damage is going to be a lot less than the water damage.
Because it is a public building, the wiring would be protected with ground fault interrupters in any areas where water is. These will nearly always trip way before a fire can start.
The water system is also a simple fix. If you don't have a night watchman, there is no need for a water supply in the building at night. (Sprinkler system has it's own dedicated water line.) Easy solution would be to shut off the water main. A little bit more complicated, but easily done, is add an alarm to the water main so that any flow when the alarm is turned on triggers the alarm. The cost of such a system is probably less than a thousand dollars.
Absent someone intentionally doing something, museums are well protected from fire and water damage.
Best of luck,
Jim Clark-Dawe