A piezo-pickup is a contact-type pickup, as opposed to the more frequently used magnetic pickup on electric guitars.
On electric guitars, this kind of pickup is supposed to give a more "acoustic"-sounding sound.