Even the rain couldn't put a dampener on the Lord Mayor's Show