Gallery closure labelled a 'national tragedy' as art world calls on council to step in