The Red Rocket near Sanctuary Hills works like any other settlement, so you can totally get food and water producing structures built there. Only problem is that all the food ones (unless someone with more knowledge wants to correct me) require settlers to work the fields in order for them to produce anything, so that can be a bit of a faff to sort out, unless you have Automatron of course in which case you can just build robots to do that job for you.