The leader of Rugby Borough Council has revealed why he did not join counterparts across Warwickshire in railing against plans to create a single new unitary authority.