A damning report into one of Britain's leading children's hospitals has revealed a catalogue of serious failings.