My source said I can use it at special trees but how or where does that happen and will it get consumed?
In Black version, there are no Special trees to attract Pokemon with. Instead, you can use the honey and it will attract Wild Pokemon, in a manner similar to the move Sweet Scent.
When you see the trees, you can spread honey on them. Then, after waiting, a Pokemon will appear to eat the honey.
To see locations, see http://bulbapedia.bulbagarden.net/wiki/Honey#Honey_tree_locations
How to change your username
How to add a user avatar
Why was my post hidden?
Flags vs Downvotes
Official PokemonDb League
Type a Pokemon name, type, move or ability to see instant results.