Not sure about Hound Point, which as previous posts have rightly stated, is some considerable distance up river (firth) from Leith but still looking into it.
As to the anomaly with SQ, though more commonly referred to by its full name of South Queensferry (as distinct to North Queensferry), it is I believe, equally acceptable to use Queensferry when referring to the South side only.