A royal correspondent for Sky News has been given the job of becoming a senior media adviser at Buckingham Palace.