The decision ends a longstanding agreement between the National Gallery and the Tate concerning what kinds of art each museum will target