Eyewitnesses say 38-year-old was trying to rescue passengers of an overturned car in coastal town when floodwaters carried him away