I can only guess based on your description, but I suspect you are calling the drive shaft housing the lower unit, and you are calling the lower unit the foot. Either way, we need to try to use the same terminology so that any help or instructions you receive, are not made more confusing. If the upper sleeve/tube pulls off with the water line, there may be a way to replace it, if it's like the Merc's I've had and work on. You can slip the tube onto the end of your water line just enough that it will stay lined up properly. Now wrap the top of the water tube right next to the sleeve with a few wraps of tape. A small build up of tape prevents the sleeve from sliding down onto the tube any further and will allow you to use the tube like an extension handle to push the sleeve onto the upper connection. Once you have pushed it all the way onto the upper connection, pull the water tube out and remove the tape. Then you reinstall the tube into the upper sleeve and then install the lower unit.
Any time I remove my lower unit, the water tube usually stays with the rest of the motor (inside the shaft housing). But on the occassions that it pulls out with the lower unit, I just reinstall the line back into the upper sleeve and go on with what I was doing. I've only replaced the sleeves when they have split or otherwise become unusable.