The McManus: Dundee’s Art Gallery and Museum honours a pioneering woman artist with a stunning new acquisition