Cheltenham’s ‘most iconic’ late-night location has had a massive revamp - and it’s opening this weekend in time for festival week