I'm a piano teacher and also work in a piano restoration company. (Teaching doesn't automatically confer technical knowledge on whether an old piano is suitable or a financial nightmare, so don't rely on a teacher to know what restoration is needed btw.) Pupils who have access to a GOOD acoustic piano generally develop better dynamic variations in their playing than those who have an electric from the start. (It's a bit like manual versus automatic car - learn on a manual, then you can do anything later.)
Which is right for your home depends on various factors, not least budget. Initially, an electric piano (must have weighted keys, as others have said) is absolutely fine and has the advantage of headphones - though modern acoustic uprights generally have practice pedals which muffle repetitive playing when needed - a practice tool rather than a performance one, though. Bear in mind electric pianos still take up lots of space if full size though (ie 7.25 octaves).
If your dc gets up to intermediate level and beyond in time, an electric piano won't give the same experience in terms of dynamics (there's no actual hammer hitting a string, and it's harder to get really beautiful dynamic variations out of electric pianos) but a digi is better than a knackered old acoustic one as it's more consistent. That said, all acoustic pianos even from the same maker/era are not created equal, original build quality is part of it but what kind of life it's had makes a massive difference, eg whether it's been cooked in a hot house or sopping wet in a damp garage, etc. Overstrung and underdamped is what you want for a start, but definitely ask a tuner for a PAID assessment of anything that seems like a bargain being sold privately - or ask for advice from a proper supplier. Not because people are inherently untrustworthy, but because they may v well not know if the tuning pins or bridge are about to fail.
There are plenty of excellent quality bargains being sold privately (we get offered probably 2 dozen a week, half of which are absolutely fine, we just don't need them) AND plenty of absolute dross. Get them checked out first and bear in mind that you'll have to budget for moving it (yes, they do need the proper equipment, we do a lot of insurance work for damage caused by guys who didn't have a clue) and tuning it.
Also, "needs tuning" sounds nice and easy, but tuning only tightens the pins so all the strings are in tune (assuming the pins are firm enough to stay where the tuner puts them)! It doesn't do anything to the action unless your tuner is also a technician (not all are) and has charged more for extra work, so if notes are uneven, sticking, not working at all, clicky, etc etc, they still will be even after it's tuned and that's not the tuner's fault!
Sorry, I could go on. Feel free to ask if you have specific questions, this is what I do :) and being in piano restoration for 30 years is the reason I've never had any money...