In CS6 it's a free and installed plug in, but I can't seem to find it. Again I have after effects through cloud.
The Puppet tool has been part of AE since CS4 and is a standard tool, so I'm not sure what you are having difficulty with. Perhaps a short excursion to the help files might be a good idea?!
It's not an effect, it's a tool in the toolbar.