Welcome, Mrd.
Not much to add, other than that I've occasionally seen properties in that area that have springs/trout ponds, so with the right set up, it's definitely doable.
You're moving to a region that has really fantastic fishing, may not rival salt water, but 40+ pound stripers, excellent smallmouth bass, and some unbelievable tailwater trout will take some of the sting out of the move, for sure.
TN also has some excellent muskie fishing, but don't tell anyone.
