The examples you give of Lie groups associated to geometric objects are the structure groups of the tangent bundles of manifolds. The tangent bundle is locally trivial, so you have a covering of your manifold and isomorphisms *over the $U_i$* (i.e. commuting with the projections to the $U_i$) $\varphi_i:TM|_U \rightarrow \mathbb{R}^n \times U_i$. On the intersections this gives you isomorphisms *over $U_i \cap U_j$* $\varphi_j^{-1} \circ \varphi_i: \mathbb{R}^n \times U_i \cap U_j \rightarrow \mathbb{R}^n \times U_i \cap U_j$, i.e. isomorphisms $g_{ij}: \mathbb{R}^n \rightarrow \mathbb{R}^n$. These can be seen as gluing data of your bundle. The "structure group" of your bundle tells you what gluing data you allow: You could require the $g_{ij}$ to be in $GL(n), O(n), SO(n), U(n), Sp(n)$ and so on. The smaller this group of gluing data is, the more special is your bundle, e.g. if you can glue your tangent bundle only using maps from $SO(n)$, then your manifold will be orientable. The buzz word to google for is "reduction of structure group".

I am not sure what you have heard about pseudogroups but there is one consisting of the $\varphi_i$ - open patches homeomorphic to $\mathbb{R}^n$ are such that the tangent bundle is trivial over them, so if you know how to glue your manifold from such patches, you get the relation to the Lie group as above.

Of course you can embed every Lie group into some $GL_n$ and require the $g_{ij}$ to lie in that subgroup, but that seems somewhat arbitrary. 

Finally some references on the Erlangen program are [Sharpe's book][1] and [this][3], where you can look for more ingredients of the big picture.


  [1]: http://books.google.com/books?id=Ytqs4xU5QKAC&printsec=frontcover&dq=erlangen+program+sharpe&source=bl&ots=xpivQQBdqs&sig=WA8S10KHqSb6b4J-b96WVTMLmGs&hl=en&ei=xWS4TMutD4OZOseRyIgN&sa=X&oi=book_result&ct=result&resnum=4&sqi=2&ved=0CCMQ6AEwAw#v=onepage&q&f=false
  [2]: http://www.amazon.com/Differential-Geometry-Generalization-Erlangen-Mathematics/dp/0387947329
  [3]: http://arxiv.org/abs/1006.2115