Harry announced his resignation in a joint statement with Prince Seeiso of Lesotho, who he co-founded the Sentebale charity with in 2006