A man has died after being pulled from a canal in Rotherham.