Two councils have approved plans to demolish a site used by car makers Vauxhall and build various industrial units and warehouses.