The Visual Dialogue art exhibition at Museum Pier brings more than 100 rare masterpieces out of private collections to the public for the first time