While travellers rarely stop to sightsee, providing overnight facilities will give historic venues an edge