Northern cities 'beyond revival'