The head of arts body Creative Scotland has insisted his “hands were tied” when the organisation closed a key fund for artists.