We have a lot of shallow water jet pumps along the gulf coast that we use for irrigation. The air is concerning and could be something simple like a check valve that needs to be tightened. Check out the SN series of pumps StaRite or Pentair offers. I think SNF, SNE, or SNL could be a good fit...