Exclusive: Labour mayors say repeated U-turns, failure to communicate successes, and the Peter Mandelson scandal are pushing voters away