A council has adopted a scheme which is set to overhaul its fleet of vehicles, leading to the introduction of electric cars and trials of alternative fuels.