'Most wanted' man hands himself to police after pub shooting