Oh, you wanna mod yourself?
Well, you'd get the Source SDK which has a map editor and a bunch of tools, then you'd need extra programs for texture editing, modeling, animation etc. Then you'd also need a compiler, at least, and knowledge in programming. I believe that the SDK files are in C.