Rising floodwaters in parts of Sydney as weather warning issued