More than 500,000 pieces of art are owned by 225 councils, the BBC finds, but most of it is storage.