High Q can mean a Low Noise figure, but it's not sufficient. In this context, I'm taking Q to mean that the components have low losses, or small parasitic resistances. High Q parts won't degrade your noise figure as much as low Q parts, but unless the components are matched to the right impedances, it won't matter.
For two identical circuits having the same “best match” component values, the circuit which has higher Q it will have less insertion loss.
Otherwise nobody will care about Q of the components, which is a “killing” factor in Radio Frequency Design.
Following my explanation above, mean that the Q of the tuned circuits in the front of the LNA it will affect the SNR of the receiver.
Exactly what the initial question is about.