An Australian boy attacked by a shark in Sydney Harbour has died in hospital, his family has announced.