You can use any type honey. If you want to get any of the honey flavor add it at flame out.
Honey ferments quite completely so it tends to increase alcohol and makes the beer lighter. I've seen it and used it in many recipes from a very light ale to Porters.
What type beer were you thinking of?