The death of a 54-year-old man in Sydney’s Northern Beaches is being investigated as mystery surrounds the final hours of his life.