I am a podiatrist looking to put together a small unit for a foot that behaves like my air jet tub in my house. I am not sure if this even exists already on the market. Am interested in air being injected into a pool of water with the water remaining in the inner basin . What kind of compressor? Any clues on how I can approach this project?

 

Couple of dozen products that already do that:

foot soaker massager - Google Search

Unless I'm missing something here.