I deployed them in forts and they did work, but I've never garrisoned cities heavily (at most 6 units), unless in war-zones, so I don't really know if they work aswell...
I'd imagine it doesn't make any difference, since the katapeltai make AI stacks retreat even in the open...