To query a machine with SNMP, does it need a service running on the machine?

Yes, the managed device must be running an SNMP agent, this is typically built into most devices and simply needs to be enabled.

On windows, the SNMP agent is not installed by default and must be added to the running system.