Former nightclub site to be car park as pocket park scrapped