You will probably not be able to find piracetam in typical stores. I have never seen it, even at specialty supplement and health food stores (I have no idea why). Even if you can find it in normal stores, pre-capped doses will be far overpriced. The best thing to do is to buy the powder in bulk form online and mix it into a drink (orange juice, coffee, or soda all mask the taste well).
Calling piracetam a "smart pill" is a bit misleading. The effects of piracetam are subtle even at best, and even then it must be taken regularly for several weeks to reach full effect. You may find that it increases verbal recall or allows you to more quickly absorb information that you've read. I haven't noticed any significant increase in memory (after taking 1-2g a day for two months). The biggest benefit I gain from piracetam is that it allows me to think more clearly when I'm tired. I'll still feel just as tired, but piracetam makes my mind feel less foggy.
Piracetam has a highly variable effect on different people. However, it's very cheap and very safe, so you might as well give it a shot. Just don't expect anything drastic.
Also, be careful when combining piracetam with drugs. It significantly lowers tolerance towards alcohol (to the extent that I can have a really strong buzz after one beer and be drunk after 3). It also seems to drastically increase the potency of most psychedelics. Check out Xorkoth's 2C-E trip report on Erowid for an idea of what combining piracetam and psychedelics can do.
