One man has dead while his friend has been rescued by a brave witness after their boat capsized in Adelaide overnight.