With Europe’s largest sculpture park and galleries showcasing modern and contemporary British art, this former industrial powerhouse has a lot to feast your eyes on