Permission has been granted to turn the old Cathedral Square toilets into short-stay accommodation.