Police in Sydney are investigating after a statue of British explorer Captain James Cook was sprayed with red paint and damaged two days before Australia's national day.