Nearly one million people will be referred for singing or art activities by doctors under a £5 million plan to roll out