Personally, I think that neither using Detect Hidden nor Lockpicking should reveal oneself.
At the very most, it should be a scalar chance thing, depending on the skill ability in detecting hidden, hiding and lockpicking so that at highest levels, these activities should not reveal oneself.
I mean, Hiding is 100,0 skill points and so Lockpicking and Detecting Hidden, adding Stealthing we have some 420 skill points out of the 720 total max. That's a WHOLE lot of skill points invested.
I think that if a template has them all, the very least which they deserve is NOT being revealed when detecting hidden or picking a lock.
Of course, if someone else is detecting hidden on a hidden character this activity SHOULD have a chance to reveal the hidden character.
What I am saying, is that the "act" of performing detect hidden on "someone else" should NOT reveal the character performing the detect hidden activity but ONLY the target of the activity if the random generator decides so.
Example.
Player A has all maxed out hiding, stealthing, detect hidden and lockpicking.
Player B has 90,0 hiding.
Player A uses, while hidden and stealthing, detect hidden on player B (well, on an area where player B is hidden).
While the act of using detect hidden SHOULD reveal player B, it should NOT reveal the performing character of the act, player A.
That's how I think it should work.