Simon Case, the UK's top civil servant and Cabinet Secretary, has announced that he will be resigning at the end of the year due to health reasons.