Exhibition next autumn marks return of the artist’s work to the city where she was born