Billy Connolly's Big Wee Exhibition will be at the city's Kelvingrove Art Gallery from next June .