From the old English “pisser” meaning something very unpleasant or painful. Local Massachusetts accent caused the “r” to be dropped and slang usage caused the meaning to be reversed, creating the word pissa.
An interesting development is that the Massachusetts accent also adds “r’s” to the end of words where they don’t belong. Consequently, people have started once again to say pisser.