Christopher Brain, 68, from Wilmslow, was the leader of the Nine O'Clock Service in the '80s and '90s