If you are looking to rent a CS server, I'd recommend Game Servers (formerly Clan Servers). They offer CS 1.6, CS: Condition-Zero, and CS: Source servers starting at $1.99 per slot, and even less for private servers. They offer powerful server hardware with the performance and stability you would expect from a top-tier game server.

Game Servers (formerly Clan Servers) has US locations in New York, Chicago, Dallas, Atlanta, Los Angeles, San Jose, St Louis, Tampa, and Seattle. They have European locations in London, Amsterdam, and Germany. With all those locations, you should be able to find something near you with excellent pings.

More Information: Game Servers Website