A surfer has died after being mauled by a shark in front of terrified beachgoers on Sydney's Northern Beaches.