hi zax,
The flow of water is restricted by the various pipe lengths, fittings and valves you have installed between the tanks. The change in pressure is also a function of the thermodynamics of the air in the tank and heat transfer.
Look through this post
here to get a general idea of some of the concepts and what you might do to calculate things. In your case you might want to simplify the heat transfer and thermodynamics a bit. If you need help understanding flow restrictions, check the attached. Generally in industry, we use the Darcey Weisbach equation as indicated on the attached.