Just to complement Hackworth's answer explaining how this actually works (you activate the ability only when Scrapheap Scrounger is in the graveyard), I thought it might be helpful to point out how an ability that works roughly how you describe might be written.
The closest thing is probably regeneration. For example, Drudge Skeletons says:
{B}: Regenerate Drudge Skeletons. (The next time this creature would be destroyed this turn, it isn't. Instead tap it, remove all damage from it, and remove it from combat.)
You activate the ability before it dies, and it creates a "regeneration shield" so that when it would die, it instead gets to stick around as described. Applying the regeneration shield is an example of a replacement effect. In the end this is sort of similar to what you describe, in that it lets you pay mana, perhaps in response to something that would kill the creature, in order to prevent a creature from dying.
There are also other kinds of replacement effects that can prevent creatures from dying, like Necromancer's Magemark:
[...] If a creature you control that's enchanted would die, return it to its owner's hand instead.
The words to note there are "would" and "instead", which indicate a replacement effect. This time there's no mana payment involved, but it still does prevent a creature from dying. This is a pretty rare effect, though; it's far more common to see dying replaced with something even worse: "If a creature dealt damage this way would die this turn, exile it instead."