Well, this is a possibility:
http://gamebanana.com/skins/89389
The mod replaces the blood and gore with that of the (heavily censored) German version. Blood is either oil or sparks, doesn't stick to surfaces, and gibs are replaced with random crap like gears, springs, rubber ducks, and cheeseburgers. Does not remove blood from some later weapon models, but it may be enough. (Does not work on all servers, some disable custom textures) Installation instructions are on the download page.
It shouldn't trigger VAC as far as i know, but do a bit of research beforehand just in case.