Aberdeen Irish bar reopens to the public