You cannot say that because "avail" is a noun, but you need an adjective or adjective phrase. "Of no avail" or "to no avail" can act as adjective phrases. Alternatively, you can use a more straightforward adjective: "I am afraid of my work being useless."