A tax, which would have seen a charge of around £2 per night for hotel guests, will not be going ahead.