powerheads are basically something that sucks in water one end and shoots it out the other, it gives water circulation.
They are mainly used for SW aquariums that have live rock as its 'filter', this is porous and therefore nitrifying bacteria can live in it, and the powerhead is there to create water circualation around the tank and therefore a water flow through the porous live rock.
In the standard FW tropical aquarium you dont need on of these unless it is part of a filter, particularly undergravel, or if you want it for any other reason.