What's wrong with the current one? I assume it's damaged in some way or you wouldn't need to replace it.

Assuming we're referring to the type that go under the BB shell, I find that most cable guides tend to stay put under cable tension only - one of my bikes doesn't even have the screw holding it on.