The Queen's private secretary has confirmed he is leaving but says he is confidently handing on the job, knowing the monarch's "unwavering commitment as sovereign" has the "full and active" support of her family.