Heavy rain across most of Scotland could bring “significant disruption” in the build up to Hogmanay, forecasters have warned.