Hello Marqson,

I've tried to create the upper connection with the blend-tool. First I created two circles and make a surface with loft. After that I have created the 2 sidefaces of the part where the water comes out(I will call it ???). Then i've connected this two sidewalls with blend G2. After splitting the cylinder and the new blendface, I cut away the gap for the blend between ??? and the cylinder. I have made a blend with the option G2 and "planar section" for close to the cylinders tangent. The other side of the model have a different cutout with a imperfect patch made with network. It has a little tangent/curvature problem.

I hope it helps!

Kind regards
Karsten