One of my favorite places is a LYS. I know what you mean when you said " I feel like a kid in a candy store", so do i.
I wish i knew more about knitting as i would love to work in one. Heck i would volunteer my time just to be in a LYS for hours
The City i live in has a darling YS within 7 minutes of me. (driving). The store is very small but oh the yarn she has. The walls are lined with beautiful yarn. I am so lucky.