I think you would be better talking to your local tourism people and asking for their advice on how to market to your target audience. They will know how to market tourism and business accommodation in your area.
Unless the publication you are looking at is very much aimed at your target audience in terms of guests looking to stay in your area in your sort of property its unlikely to give you much relevant exposure.
Any ad needs to be well designed with your target audience in mind with a strong offer and call to action.
However a single ad in itself is likely to have little impact.