It is not clear from your question whether the gas in the bottle starts out as air, or the only substance in the bottle is water, either in liquid or gas form. I'll assume the latter since it's easier to answer.
Once the bottle is closed, ambient temperature doesn't matter. The pressure of the gas part in the bottle will be stricly a function of temperature, with that function being solely a property of water. You can find what that function is in what is commonly referred to as a steam table.
As you heat the bottle, and presumably everything inside gets to the same temperature, the vapor pressure increases. This causes a little more of the liquid to boil and thereby make less liquid and more gas. Eventually for any one temperature, a new equilibrium is reached where the gas is at the pressure listed in the steam table for that temperature.
If you let the system reach equillibrium at 200°C, for example, then open a valve at the bottom, water at the bottom will be forced out under pressure. As the volume of water in the bottle decreases, the volume available to the gas increases, which decreases its pressure. The liquid that was at equillibrium now no longer is, since its pressure is reduced but its temperature (for the short term) remains the same. This will cause the liquid to boil and make more gas. This cools the liquid, and if done slowly enough the liquid will track the ever decreasing boiling temperature for the ever decreasing pressure.
Meanwhile, the gas is expanding, so it will cool. It won't condense because there is no place for the heat to go. We are making the assumption that the bottle is insulated at this point. Boiling liquid will keep the gas "topped off" at whatever temperature it is according to the steam table.
Once all the liquid is gone, the steam will still be at pressure above ambient. If the valve stays open, the steam will vent until its pressure is the same as ambient. If the bottle is truly insulated, nothing more should happen. If heat is lost thru the bottle, then the temperature will decrease and the pressure of the steam decrease, again according to the steam table. Outside air is then sucked into the bottle. If this air is at 20°C, for example, it will significantly cool the steam, which will cause much of it to condense, which creates lower pressure, which sucks in even more cool air, etc. The proceeds until most of the water is condensed to liquid, with the only remaining water gas being whatever maximum partial pressure of water that air at that temperature and pressure can support.
If the valve is opened so that the 200°C water is expelled "quickly", then it gets a lot more complicated because there is not enough time for the system to track equillibrium as pressure is abruptly release. In that case, I think all we can say is that a bunch of super-heated water will be violently released and quickly undergo decompression, which will cause some of it to boil quickly, making a lot of steam, with the left over liquid being at boiling temperature for ambient pressure, which would be 100°C. After the water is gone from the bottle, a rush of steam will come out, condensing in the (relatively) cold ambient air and adding to the already large saturated water vapor cloud. Once enough steam is expelled so that ambient pressure is reached the remaining steam acts as above.
The default Bernoulli equation for incompressible fluids does not consider losses, however you can add correction to it, which leads to the following equation:
$$
p_1+\frac{1}{2}{\rho}v_1^2+{\rho}gz_1=p_2+\frac{1}{2}{\rho}v_2^2+{\rho}gz_2+\left(f\frac{L}{D}+{\sum}K\right)\frac{1}{2}{\rho}v_2^2,
$$
where $p_i$ are pressures, $\rho$ is the density of the fluid, $v_i$ is the average flow velocity, $g$ the acceleration due to gravity, $z_i$ the height, $f$ the friction factor, $L$ the length of the pipe, $D$ the diameter of the pipe and $K$ additional friction losses (such as in- or outlets, bends in the pipe, ect.).
(1) This gives the pressure difference between $p_1$ and $p_2$, so 30 psi or 207 kPa.
(3) This is the diameter of the pipe, so 0.01384 m in SI units.
(2) From this the volume flow rate can be determined and when combined with the diameter of the pipe, then the velocity can be determined, this assumes that the pipe has a constant diameter. Thus $v = v_1 = v_2 = \frac{4V}{\pi D^2t} = 0.7397\ \frac{m}{s}$.
The density of water at 16°C is equal to 999.2 kg/m${}^3$. According to your profile you are from Massachusetts, so for the acceleration due to gravity I will use 9.804 m/s${}^2$. I am not sure how to interpret the height difference, I will assume that you measured the pressure difference between the faucet and atmospheric pressure, such that this already incorporates the hydrostatic pressure and thus both $z_1$ and $z_2$ can be set to zero.
This allows us to rewrite the first equation to,
$$
\Delta p = \frac{1}{2}{\rho}v^2\left(f\frac{L}{D}+{\sum}K\right).
$$
To determine $f$ we first need to know the Reynolds number (and possibly the relative roughness of the pipes if the flow is turbulent). The Reynolds number can be calculated as follows,
$$
Re = \frac{vD}{\nu},
$$
where $\nu$ is equal to the kinematic viscosity of the fluid. The kinematic viscosity of water at 16°C is roughly 1.12 10$^{-6}\ m^2/s$. This leads to a Reynolds number of 9141, which is definitely well within the turbulent regime, which would require relative roughness. For this I will assume a value between 0.001 and 0.01, which lead to a friction factor of 0.035 to 0.043. I will assume that the length of the pipe is roughly equal to the sum of the vertical and horizontal distance, since pipes usually are incorporated into the walls and floors and do not travel diagonally that often. Thus $L$ would be roughly equal to 45 feet or 13.7 m. Combining all this information allows use to guess the sum of loss factors,
$$
\sum K = \frac{2\Delta p}{\rho v^2} - f\frac{L}{D} = 719 \pm 4.
$$
To get an idea of how much this is, every connection between two pipes segments adds 0.08, a right angle outlet (such as a faucet) adds 1, a 90° bend adds 0.75 to 1.4 (depending on the radius) and a completely open faucet can add 0.15 to 10 (depending on the type). Without knowing more exact numbers for the length, the amount of bends, it will be hard to tell how clean the pipes are. For instance the length will probably much longer since there will also be pipes before the main faucet.
Best Answer
The answer depends on the shape of the vessel.
For a vessel with constant section, the weight of the column of water above your transducer is unaffected. But when you have a conical vessel, some of the mass is no longer "directly above" your transducer as the liquid expands. If the cone gets wider, you will feel less weight; if it tapers narrower you will feel more weight.