The supermarkets near you will have it. Supermarket chains usually sell it in a refrigerator section. If you have an Italian specialty grocer they should have it also.
Even in Italy they used dried pasta for certain dishes. It really matters on the dish whether dried or fresh is most appropriate.
De Cecco is some of the best dried pasta on the shelves and I believe they even have an egg pasta, which would be the closest to fresh pasta, if you can’t find fresh pasta, but can find De Cecco on the shelves.
I don’t buy fresh pasta, because I stay away from egg yolks, and for many things I prefer the dried pasta anyway. No question fresh pasta can be amazingly delicious though. I don’t find the fresh pasta packaged for chain stores is the same as scratch from your kitchen, but I guess you will prefer to to dry pasta if that is what you are looking for.