An elderly man has died and a woman is in hospital following what police described as a "serious incident" in Perth's northern suburbs.