Electrical tape, even cheaper tape, can work fine.

I don't use any tape. I end the bar tape on each side of the brake lever, under the hood. A dot of superglue holds each end in place. Very clean looking with no bulges.