find block player is looking at

I am making a procedure for a tool that lets you pan for gold

How would I find the block that the player is facing and if the block is the specified block (sand/gravel), then give an item out of a loot table or manually enter in the procedure