Bosses say £40m is needed to secure the future of Scotland’s national art collection