'n means a or an. Afrikaans has just this one form, so it does not switch between two versions the way English does.
In this sentence:
The apostrophe is just part of how the Afrikaans indefinite article is written. You should learn 'n as a fixed form.
A very important spelling point: 'n stays lowercase even at the beginning of a sentence. So you write:
not with a capital N.
Yes. This is the standard word order for a simple statement:
So it follows the basic pattern subject + verb + complement.
More generally, Afrikaans main clauses usually keep the finite verb in second position. In this sentence, the subject comes first, so is comes second.
Usually no. In this sentence, sukses is a singular countable noun, so Afrikaans normally needs the article 'n. The natural sentence is:
Die projek is 'n sukses.
Without 'n, it sounds incomplete or unnatural here.