Consider a cylindrical water container on a balance. Suppose the water surface is initially at level $h$ above the balance. The pressure at the bottom of the container is then $$p_i = p_0+\rho g h,$$ where $p_0$ is the atmospheric pressure. Because the air pressure also acts on the opposite side of the balance, the balance reading is $$m_cg + a\rho g h,$$ where $m_c$ is the mass of the container and $a$ is the cross-sectional area of the container.
Now suppose we create a hole in the container at some level $h_t$ and insert a tube trough the hole. Let $A$ be a point at the water surface, $B$ be a point at the end of the tube inside the container and let $C$ be a point at the other end of the tube, outside of the container.
With obvious notation, we then have, by Bernouilli's principle, $$p_0+\frac{1}{2}\rho v_A^2+\rho g h = p_0 + \frac{1}{2}\rho v_C^2 + \rho g h_t$$ and $$p_B + \frac{1}{2}\rho v_B^2 + \rho g h_t = p_0 + \frac{1}{2}\rho v_C^2 + \rho g h_t. $$ Since the flow is incompressible, we must have $v_B = v_C$, and consequently, $p_B = p_0$. This all seems well, there shouldn't be any pressure drop for an ideal flow in a horiontal pipe of constant cross-sectional area.
However, what does this imply for the balance reading, since we now have $p \neq p_i$ at the bottom of the container? Is it going to drop dramatically? Certainly, at other points on the streamline we are not required to have $v = v_C$, so the pressure can be greater there. At the same time, it would surprise me if we could have a pressure $p \approx p_i$ near the bottom, as this would imply, for large $h$, a large pressure gradient along the bottom towards the tube.
Perhaps my question isn't very well phrased. Although I haven't yet done the experiment, it seems that simply drilling a hole in the container would dramatically decrease the balance reading, which seems rather counter intuitive to me.