A Rotherham village has been warned to expect flooding overnight with homeowners urged to “act now.”