Record rainfall across Sydney and parts of NSW have caused flooding and widespread damage with authorities issuing evacuation orders for some communities.