Scots have been warned to brace for “significant disruption” with up to 140mm of rain predicted to fall in 24 hours.