A man has died after drowning in waters near a Melbourne pier.