The popular hotspot was once the UK's largest indoor waterpark, pulling in huge crowds of visitors from near and far. But after years of decline, it has been demolished leaving no trace behind