The Welsh-born politician was credited for smoothing the often strained relationship between Tony Blair and Gordon Brown