My experience over the last decade would lead me to believe the the best answer is it is agency dependent. Saying most sheriffs offices allow it would be a bit misleading in my experiences/opinion.
Stay safe
Yes it is very much agency dependent. In Greene County, as a Reserve, you must provide your own firearm. It must meet certain criteria though(i.e. caliber).