The-dad-of-two was last seen in a 'sleepy state' and sitting on the wall beside the river in Heywood