If you are caught driving above the legal limit of 0.05% you are fined roughly $570, are prohibited from driving for 1 month, and receive 2 “points”. Points accumulate and once you reach 8 you lose your drivers license. In this case you would keep the points for five years. Many different driving offences give you points.
For comparison, to get a similar penalty by speeding you would have to exceed the speed limit by 51 km/h (32 mph).
There are many additional related offences you could commit, with different consequences. Repeat offences to the above, for example, are punished more severely: you get 3 months instead of 1 and the fine is doubled and tripled for the second and third offence, respectively. Already with a blood alcohol level of 0.03% you risk legal consequences, e.g. if you make an error while driving. If you endanger someone else (or property) with that level you are committing a crime, will lose your license, and can go to prison. If you are in your probationary period (two years after acquiring your license), any nonzero level is an offence.
Losing your license is generally temporary. You are blocked from re-acquiring it for some time, depending on the offence (at least 6 months, but can be multiple years). You have to complete an MPU, which certifies your ability to safely drive. For alcohol based offences, this would include demonstrating that you have reduced your consumption significantly. This can be quite harsh; you may, for example, be required to show complete abstinence for a period of one year. Of course, you are also looking at costs close to $1000 for the MPU alone. It is possible to get permanently blocked from driving, but it's quite difficult, I believe.