Search and rescue efforts for a Cairns man reported missing in a causeway ended with emergency crews locating his body after he had failed to resurface from water.