What Is A Noun That Functions As An Adjective Called?

There is no specific name for a noun that functions as an adjective. It is simply defined as a noun that functions as an adjective to describe the kind of noun under discussion. For example see the sentence below"

The water pump is broken.

Here the basic noun is pump but another noun water is used to describe it. This noun is functioning as an adjective as it is describing the pump.