National Gallery and Art Fund select Southampton and Sheffield sites for curatorial partnerships