A shooting in Sydney has resulted in one death and four injuries, with an active police response ongoing.