The Witcher 2: Assassins of Kings
Looted from the body of the harpy queen in the harpy lair.
The Witcher 3: Wild Hunt
Harpy returns as a silver sword in the third game, this time with several different forms:
Harpy (crafted)
Crafting Requirements
Harpy (relic)