Queen Elizabeth II's private secretary, known for modernising the British Monarchy's relationship with the press, has died age 96