A man is dead and a homicide investigation underway after a shooting in Sydney's west.