To answer your specific question, the effect of the reduction in pressure in
the tank will of course reduce the NPSH available at the pump suction.

If the NPSH Available drops below, or close to, the NPSH required by the
pump, then the pump may begin to cavitate.