Don’t live in Vermont, but I have experience with most of the Northeast.
There is very little water in or around Vermont. It does not border the Great Lakes. The best you’ll get is a decently sized lake in the Northwest and that’s about it. Very few rivers or waterways as well.
Vermont is also absurdly expensive. If you don’t have higher then a 6 figure salary you will suffer and struggle immensely. The housing market is unlivable.
The nature is gorgeous though. Absolutely breathtaking. But you can get the same thing almost all along the Appalachians.