Front drains for the W123:-
It eventually comes out in the wheel arch just behind the front wheel on this bit:-
Sunroof drains from the front come out from behind the front wing / fender a little further back - if you remove that plastic panel shown above you can see a bit of rubber tube right at the top of the inside of the wing.
Sunroof drains from the back come out just behind the rear doors on a sedan on the pillar - just behind a thick bit of trim.