I don't see a picture of a pipe sticking up from the ground. (If adding any more pics, please put them directly in the thread instead of using links to Imgur.) Hard tellling what you have, so far.

Hello, and thank you very much for responding!

I've uploaded the pics below.

I think the next step is exploration. Connect the pipe to a water source in some temporary manner and test it out. If the pipe is the duct for the sprinkler head, very likely it would have been using a manual timer as you referenced in one of your links.

Thanks... I will do that! If it does in fact run that sprinkler head, along with timer, what else would I need at the spigot area to make it complete system (even though it might just be a basic on head system)?

Without knowing what was in the builder's mind, as the spigot is an odd contraption, the pipe could be that large for any number of reasons, one of which being because it was the default, on-hand material.

If the spigot itself is functional, you only need to go to Home Depot, get about 30 odd possible connecting parts, and after getting home figure out which 5 or 6 of them will actually work to connect it to the pipe. Still a part or two short? Return to Home Depot and get a dozen more connectors which will most likely contain the actual parts needed. Possibly, there could be a third trip involved so hopefully you will not be starting this project too late in the day.

Thanks, the spigot definitely works as I've connected a standard garden hose to it. Do I need anything for back flow?

So, with the garden hose connected you only get water out of the one sprinkler head?

Why bother? Just run a hose over to the area you want to water - it appears to be only 8-10 feet away.

If it's going to be put in use, "yes" to the backflow preventer.

@Stax, i'm trying to see if this sprinkler head can water my entire front yard (not pictured).

@Yardvaark, if this works and I would love to use it :-) So i'm wondering what is everything I need to get this to be a fully functional system (albeit a small one).

I wish I could tell you but my trips to big box to fix plumbing problems are literally like I suggested above, but probably worse ... 6 trips instead of 3 or 4! Even though I many times roughly draw out what I need, the plan changes and I eventually need other things or just got wrong to begin wih.

The spigot has hose thread and the pipe has pipe thread. You'll need to adapt one to the other somewhere in between. Take the picture to the store, find the plumbing person and see if they can help you figure out what parts you need. I presume you'll want that manual time timer in the chain of parts so be sure to explain that.