Glory Holes are most often found in "adult" establishments... adult theaters.. novelty (toy) stores.. adult video stores (those that you often see on the long interstate trips thru rural areas)... and the like..

They are exactly what Catch22 described (from what I have heard)... and are often in small "viewing" rooms.. (where you can watch strippers.. or videos)..