Simon Case, the UK's top civil servant, has declared his intention to resign from his position at the end of the year due to health reasons.