The former BBC, ITV and Sky News journalist has died after revealing he had stage four prostate cancer.