When water slowly flows out the sphere, the $C.G.$ of the system is lowered, and hence $l$ increases, which in turn increases time period (as $T \propto \sqrt l $).
After some time weight of water left in sphere become less than the weight of sphere itself, so the resultant $C.G.$ gets clear the $C.G.$ of sphere itself i.e. $l$ decreases and hence $T$ increases.
Finally when the sphere becomes empty, the resulting $C.G.$ is the $C.G.$ of sphere
i.e. length becomes equal to the original length and hence the time period becomes equal to the same value as when it was full of water. 

