A popular holiday hotspot will enforce a ban on night time flights at its airport, a decision likely to greatly affect many tourists.