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? The points system Question etiquette Flags vs Downvotes Anime FAQ
Type a Pokemon name, type, move or ability to see instant results.