Had some square drain pipes and all the connectors that came with the water butt assumed they'd be round, so I made one myself.

Works great, tight fit, the circular printed pipe fits through the hole at the bottom and should sit flush with the inset. The hose connects to it.