Police have confirmed a six-year-old boy and four-year-old girl died after being pulled from Perth's Swan River, ahead of New Year's Eve celebrations.