Police are investigating after an shooting and car fire in Sydney's northwest overnight.