Two people have been shot dead, and dozens injured, in a shooting at a neighbourhood street party in the US.