I can see that without the drain, x would quickly overflow, but I cannot imagine even if d was 0 (the drain is still open to the atmosphere) that this would occur.
Actually Y is small compared to d (not drawn to scale), but I am curious as to how multiple resevoirs affect the pressure and flow...