Glasgow man who 'couldn’t hold down jobs because of drinking' turns life around