‘Once-in-a-lifetime’ cosmic event to appear in night sky after star explodes