From restaurants with rooms to historic priory hotels, here are the Welsh county’s best stays