Simply wielding the weapon will raise your Item Discovery stat, making it great for farming.
Because of this, you'll only want to equip this when you have a farming spot close to a bonfire - or at least pack lots of Estus. This helm boosts your Item Discovery Rate - but at the cost of constantly draining health. Every Mimic you meet has a chance to drop it, but the last Mimic left in the game should drop it regardless - if you haven't found it before then. Dodge it or kill it, and look around its lair for a body holding the shield.
Take a detour down the bridge before High Lord Wolnir to enter the Smouldering Lake, and head left to where a Giant Sand Wurm has made its home. The Shield of Want is a special magical shield that allows you to obtain more souls from enemies, much like the Covetous Silver Serpent Ring - though it's located about halfway through the game.