We have a create section with a lot of information about how to create content for wesnoth.
Personally, I started learning it by downloading an era from the addon server, looking into the files and trying to comprehend how it is done.
As for sprites, GIMP will do the job.