The 24-bedroom property is on the North Coast 500 road trip route