Rare green comet to be visible before disappearing for 1,000 years