A thriving food scene, world-class museums, and unpretentious charm make North Carolina’s capital a deserving weekend escape.