This phrase has a multitude of uses, but two of the most common are:
1. An exclamation often preceding a statement of awed disbelief.
Holy friend of Piglet! The plane's going to crash!
2. A derogatory term for someone of low character.
You think you can steal from me, you little friend of Piglet?