pingelid,
It seems like you could use the flow accumulation grid somehow to do this.
I tried to look at the one I'm working on using the "unique values" symbology. I removed all the values and then tried to add values. I have a 10'x10' grid so 25 acres = 10890 grids. I tried to add multiples of 10890, but only rarely did I see an exact multiple. It was time consuming and I could see that I wasn't going to get what I wanted early on.
The USGS tool might be useful, but not if you need the results in your specific dataset on you desk top.
In the Arc Hydro workflow, there is a point where, before the stream definition, you ask it to start the stream only at a certain number of cells. I set the value at 10890 (25 acres) and ran the whole Arc Hydro workflow to AdjointCatchement step. Then used the Point Delineation tool and checked. Sure enough, when I delineate a watershed at the upstream end of of the drainage lines, I get really close to 25 acres.
So, this would take a while, but you could:
* run the process up through stream definition and then once you have the fac grid use 25 acres, 50, 100, 125, etc. worth of grid cells to produce several str grids (str25, str50, etc)
* convert the strs to lines using Conversion Tools > From Raster > Raster to Polyline.
* Place (snap) batch points at the upstream ends of the stream networks (this would be much easier than stopping at the str grids and visually trying to place the points on the grid cells).
* Run batch subwatershed delineation on the points.
It seems it would take some patience to place the points, but you could use model builder create automate the creation of str25, str50, etc. grids and convert them to polylines.Then, after you manually place the batch points, you could do the subwatershed delineation in one operation.
If there was tool to place the points a the upstream ends of the str's polylilnes automatically that would allow automation of the whole process. Maybe someone could write a script to place a point at the high value grid cells of the str grids (?).
FYI - I tried this to the 25 and 50 acre level. The results were mixed. I got mostly 25 acre watersheds, did get some larger, up to 39 acres.
It seems that the stream segmentation function may have some logic in it where it allows a watershed to be larger when there is a certain condition. I can see this when two small watershed branches come together and each subwatershed is smaller than the desired starting stream size, but when they come together, combined they are larger. At this point, I think it would start the stream at the confluence.
Let us know what works out in the end.