South Yorkshire will be the latest region placed into Tier 3 coronavirus restrictions, the Sheffield City Region mayor has announced.