A local authority county manager is at loggerheads with the vast majority of his elected members over a housing zoning beside an internationally important site for a rare bat.