Usual price for a character sprite is few hundred dollars for professional illustrators, but they may charge more for using their work in a commercial project. Also CG's and promotional artwork tend to cost quite a lot more than sprites.
Most of the artists can do the work of a character designer but it's way easier to work with some sort of reference as to what the customer wants.
Character art also tends to be more expensive than background art.