South Yorkshire has the potential to be in the ‘vanguard’ of a new national drive to revitalise industry, says the region’s mayor.