Torrential rain, dam overflow trigger flash flooding in Sydney