A man in his 20s has sadly died and two other men are in hospital after a serious crash in Rotherham, police have confirmed.