A police officer is dead after being struck in the head, with what's understood to be an axe at a property in Sydney's north west.