Mayor secures £166m transport investment for South Yorkshire