A former nightclub is set to be demolished and replaced with 29 flats, despite claims the six-storey block will clash with the rest of the area.