Industrial English city with ‘worst high street in Britain’ is being transformed forever in huge £85m shake-up