Industrial UK town dubbed ‘hell on earth’ to turn shabby old shopping centre into ‘go-to destination’ in huge revamp