For enahnced WC3 abilites, it is JNGP (JassNewGenPack).
For art it is some art program, 3Dstudiomax for models and photoshop (or other graphic packages) for textures.
For SC2 abilites, it is the StarCraft II Editor.
SC2 art is the same as WC3 art (just different formats and specifications).