I fill up my humidifier tanks several times a day. The tanks don't fit under my kitchen sink, so I have to fill them partially in the sink and then the last 10% with the sprayer. The sink has a flow restrictor, and of course the sprayer is inhibited by turning the water into a spray. Additionally, it's a cheap faucet where the water does not get cut off to the sink when the sprayer is engaged, so there is a half flow that goes to each.

What I would like to do is:

1. Replace the sprayer head with some other apparatus which will allow me to completely turn the flow on and off.
2. Replace the sink aerator with some other apparatus which will allow me to completely turn the flow on and off. There are some aerators on the market with this feature, but my initial research showed that at least some of them don't completely turn off the flow, and I'm not sure about the others.

update: Apparently there is a value that shuts off the sink water, it recently started working. So issue #2 has gone away.