Artists are facing a ‘crisis’ in securing spaces within cities in which they can work, according to the Arts Council.