does the irrigation pump stop on its own or does it have to be turned off manually after every use?

No once primed it should run through the cycle.

You will need to add either a relay switch (hooked to your irrigation clock/timer) or a pressure switch (from the outlet pipe.)