The US consulate building in Sydney’s north has been vandalised, in an apparent pro-Palestinian protest.