Generally what you want will be found at a well-stocked hardware store in the plumbing area as a "portable dishwasher" hookup - often with a quick-connect fitting on each half, and frequently with an extra quick-connect half to remount the aerator, or with a different aerator built into it.
The faucet-end is normally one of a few specialized "aerator" threads (the part you most likely took off to find those threads) and the hose looks like a standard garden hose thread.