Apart from being a beautiful city, Edinburgh also hosts the biggest public fireworks concert at the end of the Internation Festival. There are various vantage points to observe the fireworks. The Salisbury Crags is good (my usual spot when I am feeling stingy) and obviously Princes St Gardens. I haven't made it to Inverleith Park yet. The atmosphere is great with lots of people bringing picknicks to enjoy the end of the festival madness.