Plants don't consume CO2 when they grow. They give off CO2 when they
respire just like all living things. The process of photosynthesis
has a net positive amount of oxygen during the day, but at night they
are only giving off CO2.
Carbon dioxide is added to the air in any combustion process (unless
there isn't enough oxygen in which case it is carbon monoxide)
regardless of how the fuel was made.
Biodiesel only works for cars (or boats) that have diesel engines.
And you don't have to use rapeseed oil, you can get used fryer oil
from the fast food places and use that.
For gasoline engines, you distill ethanol to get gasahol.