A red panda that was a guest favourite at one of Wiltshire’s top tourist spots has died, the safari park has announced.