Here's a collection of Scripture song resources.
http://www.thywordcreations.com/Childrens.htm Excellent CD and book set for several larger passages of Scripture. Targeted at children.
http://www.thywordcreations.com/Teens.htm This CD and book set is produced by the same folks as those in the link above, but is targeted at teens and adults.
http://www.scripturesongs.net/ These are ALL FREE! You can listen online, download the ones you like or download whole albums. There are five Scripture song albums. Many of these songs do not closely follow the Biblical text, though they are still good.
http://childrensministryplace.com/ There some great music resources here, too.