Rain is set to finally ease but Sydney homes still threatened as dam tipped to overflow for second time in three months