Sir Elton John has been a "constant support" to the Duke and Duchess of Sussex, amid their plans to step back as senior members of the Royal Family.