Details of drunkenness, fighting and late night parties at the heart of government have been laid bare in a damning report by Sue Gray - who said "senior leadership" must bear responsibility.