A councillor has expressed disappointment after plans to use 27 flats for council housing were blocked