A production of Singin’ in the Rain drops 12 tonnes of water on the stage each night, writes Tina Darb O’Sullivan.