The Thunder Slide at Village Square Leisure Centre will be replaced after more than 30 years in service.