A comet which was last seen 80,000 years ago is now visible in the North East