The man and his partner were pulled out of the water by beach-goers after calling for help; resuscitation efforts fail