A Scottish council has refused planning permission for a new petrol station and service area partly because the development would “increase dependency on car travel” and go against government plans to “address the climate emergency”.