The UK's quietest road is one of the prettiest but only four vehicles use the picturesque route every hour.