Hull gallery more than tripled visitor numbers during UK City of Culture year after “Herculean” renovation